package org.example.web;

/**
 * Excel参数常量
 *
 * @ProjectName: SpringBootProjects
 * @ClassName: ExcelConstants
 * @Author: MrKay
 * @Date: 2021/6/4
 */
public class ExcelConstants {
    /**
     * 每一个Sheet存储的记录数:100w
     */
    public static final Integer PER_SHEET_ROW_COUNT = 1000000;
    /**
     * 每次向EXCEL写入的记录数(查询每页数据大小) 20W
     */
    public static final Integer PER_WRITE_ROW_COUNT = 20000;
    /**
     * 读取3000条数据开始插入到DB
     */
    public static final Integer ONCE_SAVE_TO_DB_ROWS = 3000;
    /**
     * 超百万数据,每次读取10w条数据开始插入到DB
     */
    public static final Integer GENERAL_ONCE_SAVE_TO_DB_ROWS = 100000;


}
